PM Paid Transaction History File (PM30200)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Paid Transaction History File (PM30200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM30200

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Paid Transaction History File
Physical Name: PM30200
Technical Name: PM_Paid_Transaction_HIST

Group Display Name: Payables History Logical Files
Group Technical Name: PM_History_Logical_Files

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['PM Paid Transaction History File'].VCHRNMBR AS 'PM Paid Transaction History File-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['PM Paid Transaction History File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['PM Paid Transaction History File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
2	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PM Paid Transaction History File'].VENDORID AS 'PM Paid Transaction History File-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PM Paid Transaction History File'].VENDORID = ['PM Vendor Master File'].VENDORID
3	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
4	DOCDATE	Document Date	Date	DT	8
5	DOCNUMBR	Document Number	String	STR20_Document_Number	20
6	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
7	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
8	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
9	DISCAMNT	Discount Amount	Currency	DLR17_RBS0_STR$	17
10	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
11	BACHNUMB	Batch Number	String	STR15_LBAU	15
12	TRXSORCE	TRX Source	String	STR13	13
13	BCHSOURC	Batch Source	String	STR15	15
	Records whether the transaction was entered in a batch or not. Click to show/hide the Batch Sources PM_Trxent Batch XXPM_Trxent No batch (real-time)
14	DISCDATE	Discount Date	Date	DT	8
15	DUEDATE	Due Date	Date	DT	8
16	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
17	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
18	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
19	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
20	TRXDSCRN	Transaction Description	String	STR30	30
21	UN1099AM	Unapplied 1099 Amount	Currency	DLR17_RBS0_UTR$	17
22	BKTPURAM	Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
23	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
24	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
25	VOIDED	Voided	Boolean	CB	0
26	HOLD	Hold	Boolean	CB_Hold	0
27	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PM Paid Transaction History File'].CHEKBKID AS 'PM Paid Transaction History File-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PM Paid Transaction History File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
28	DINVPDOF	Date Invoice Paid Off	Date	DT	8
29	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
30	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
31	PGRAMSBJ	Percent Of Gross Amount Subject	Integer	INT5_RBS2_U%	5
32	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
33	POSTEDDT	Posted Date	Date	DATE	6
34	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Paid Transaction History File'].PTDUSRID AS 'PM Paid Transaction History File-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Paid Transaction History File'].PTDUSRID = ['Users Master'].USERID
35	MODIFDT	Modified Date	Date	DT	8
36	MDFUSRID	Modified User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Paid Transaction History File'].MDFUSRID AS 'PM Paid Transaction History File-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Paid Transaction History File'].MDFUSRID = ['Users Master'].USERID
37	PYENTTYP	Payment Entry Type	Integer	GB	0
	Click to show/hide Payment Entry Type 0 Check 1 Cash 2 Credit Card
38	CARDNAME	Card Name	String	STR15_Card_Name	15
39	PRCHAMNT	Purchases Amount	Currency	DLR17_RBS0_UTR$	17
40	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
41	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
42	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
43	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
44	TTLPYMTS	Total Payments	Currency	DLR19_RBS0_UTR$	19
45	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PM Paid Transaction History File'].CURNCYID AS 'PM Paid Transaction History File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PM Paid Transaction History File'].CURNCYID = ['Currency Setup'].CURNCYID
46	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['PM Paid Transaction History File'].PYMTRMID AS 'PM Paid Transaction History File-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['PM Paid Transaction History File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
47	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['PM Paid Transaction History File'].SHIPMTHD AS 'PM Paid Transaction History File-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['PM Paid Transaction History File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
48	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Paid Transaction History File'].TAXSCHID AS 'PM Paid Transaction History File-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Paid Transaction History File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49	PCHSCHID	Purchase Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Paid Transaction History File'].PCHSCHID AS 'PM Paid Transaction History File-Purchase Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Paid Transaction History File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
50	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Paid Transaction History File'].FRTSCHID AS 'PM Paid Transaction History File-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Paid Transaction History File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Paid Transaction History File'].MSCSCHID AS 'PM Paid Transaction History File-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Paid Transaction History File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
52	PSTGDATE	Posting Date	Date	DT	8
53	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
54	CNTRLTYP	Control Type	Integer	INT1	1
	The Control Type records the type of transaction. Click to show/hide Control Types 0 Voucher types 1 Payment types 2 Printed alignment forms
55	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PM Paid Transaction History File'].NOTEINDX AS 'PM Paid Transaction History File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PM Paid Transaction History File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
56	PRCTDISC	Percent Discount	Integer	INT5_%2	5
57	RETNAGAM	Retainage Amount	Currency	DLR17_RBS0_UTR$	17
58	VOIDPDATE	Void GL Posting Date	Date	DT	8
59	ICTRX	IC TRX	Boolean	CB_IC_TRX	0
	Click to show/hide Intercompany flag 0 Not intercompany. 1 Intercompany
60	Tax_Date	Tax Date	Date	DT	8
61	PRCHDATE	Purchase Date	Date	DT	8
62	CORRCTN	Correction	Boolean	CB_Correction	0
63	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
64	APLYWITH	Apply Withholding	Boolean	Boolean	0
65	Electronic	Electronic	Boolean	CB_Electronic	0
66	ECTRX	EC Transaction	Boolean	CB_EC_Transaction	0
	The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
67	DocPrinted	DocPrinted	Boolean	CB_DocPrinted	0
	Click to show/hide Document Printed flag 0 Record has not been printed. 1 Record has been printed.
68	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
69	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
70	BackoutTradeDisc	Backout Trade Discount Amount	Currency	DLR19_RBS0_UTR$	19
71	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
72	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['PM Paid Transaction History File'].VADCDTRO AS 'PM Paid Transaction History File-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM PM30200 AS ['PM Paid Transaction History File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['PM Paid Transaction History File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['PM Paid Transaction History File'].VENDORID = ['PM Address MSTR'].VENDORID
73	TEN99TYPE	1099 Type	Integer	1099_Type	0
74	TEN99BOXNUMBER	1099 Box Number	Integer	DDL_1099_Box	0
75	PONUMBER	PO Number	String	STR17_POP_Number	17
76	Workflow_Status	Workflow Status	Integer	Workflow Status	0
77	InvoiceReceiptDate	Invoice Receipt Date	Date	DT	8
	Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
78	LNGDESC	Long Description2	String	STR200	200

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Paid Transaction History File (PM30200)

Leave a Reply Cancel reply